create external table jms_dm.dm_forecast_active_send_arrival_hours_detail_dt (
 send_site_code string comment '发件站点'
,can_arrival_site_code string comment'到件站点'
,duration_hours int comment'耗时'
,send_scan_hm string comment'发件扫描所属时分'
,waybill_cnt int comment'单量'
) COMMENT '中心进港预测中间表'
PARTITIONED BY (dt STRING COMMENT 'yyyy-MM-dd')
STORED AS PARQUET
LOCATION '/dw/hive/jms_dm.db/external/dm_forecast_active_send_arrival_hours_detail_dt'
TBLPROPERTIES (
'discover.partitions'='false',
'parquet.column.index.access'='true'
);